Dataset statistics
| Number of variables | 19 |
|---|---|
| Number of observations | 103 |
| Missing cells | 208 |
| Missing cells (%) | 10.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 15.4 KiB |
| Average record size in memory | 153.2 B |
Variable types
| Numeric | 12 |
|---|---|
| DateTime | 1 |
| Categorical | 4 |
| Unsupported | 2 |
Channel has constant value "Reclame Aqui" | Constant |
Tickets has constant value "1" | Constant |
Requester email has a high cardinality: 103 distinct values | High cardinality |
df_index is highly correlated with Requester external ID and 1 other fields | High correlation |
Requester external ID is highly correlated with df_index and 1 other fields | High correlation |
Requester_ID is highly correlated with df_index and 1 other fields | High correlation |
Volume_CHAT is highly correlated with CSAT_Rated | High correlation |
CSAT_Rated is highly correlated with Volume_CHAT | High correlation |
df_index is highly correlated with Requester external ID and 1 other fields | High correlation |
Requester external ID is highly correlated with df_index and 1 other fields | High correlation |
Requester_ID is highly correlated with df_index and 1 other fields | High correlation |
Volume_CHAT is highly correlated with CSAT_Rated | High correlation |
%Insatisfação(CSAT) is highly correlated with CSAT_Rated | High correlation |
CSAT_Rated is highly correlated with Volume_CHAT and 1 other fields | High correlation |
df_index is highly correlated with Requester external ID and 1 other fields | High correlation |
Requester external ID is highly correlated with df_index and 1 other fields | High correlation |
Requester_ID is highly correlated with df_index and 1 other fields | High correlation |
Volume_CHAT is highly correlated with CSAT_Rated | High correlation |
CSAT_Rated is highly correlated with Volume_CHAT | High correlation |
Requester_ID is highly correlated with Requester external ID and 2 other fields | High correlation |
%Insatisfação(CSAT) is highly correlated with CSAT_Rated and 1 other fields | High correlation |
Ticket ID is highly correlated with Assignee email and 1 other fields | High correlation |
%NFCR is highly correlated with Volume_CHAT and 1 other fields | High correlation |
Volume_EMAIL is highly correlated with Tempo_Medio_Email | High correlation |
Requester external ID is highly correlated with Requester_ID and 2 other fields | High correlation |
AWT_Chat is highly correlated with Ticket created - Date | High correlation |
Tempo_Medio_Chat is highly correlated with Ticket created - Date | High correlation |
CSAT_Rated is highly correlated with %Insatisfação(CSAT) and 1 other fields | High correlation |
Volume_CHAT is highly correlated with %Insatisfação(CSAT) and 3 other fields | High correlation |
Assignee email is highly correlated with Ticket ID | High correlation |
Tempo_Medio_Email is highly correlated with Volume_EMAIL | High correlation |
df_index is highly correlated with Requester_ID and 2 other fields | High correlation |
Ticket created - Date is highly correlated with Requester_ID and 7 other fields | High correlation |
Channel is highly correlated with Tickets and 1 other fields | High correlation |
Tickets is highly correlated with Channel and 1 other fields | High correlation |
Assignee email is highly correlated with Channel and 1 other fields | High correlation |
Volume_SOCIAL has 103 (100.0%) missing values | Missing |
Tempo_Medio_Social has 103 (100.0%) missing values | Missing |
Requester email is uniformly distributed | Uniform |
df_index has unique values | Unique |
Requester external ID has unique values | Unique |
Ticket ID has unique values | Unique |
Requester email has unique values | Unique |
Requester_ID has unique values | Unique |
Volume_SOCIAL is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Tempo_Medio_Social is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
%NFCR has 28 (27.2%) zeros | Zeros |
%Insatisfação(CSAT) has 66 (64.1%) zeros | Zeros |
CSAT_Rated has 34 (33.0%) zeros | Zeros |
Reproduction
| Analysis started | 2021-06-15 16:42:15.780710 |
|---|---|
| Analysis finished | 2021-06-15 16:42:41.627107 |
| Duration | 25.85 seconds |
| Software version | pandas-profiling v3.0.0 |
| Download configuration | config.json |
df_index
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIQUE| Distinct | 103 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 489.6504854 |
| Minimum | 4 |
|---|---|
| Maximum | 932 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 952.0 B |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 54.1 |
| Q1 | 279 |
| median | 487 |
| Q3 | 720 |
| 95-th percentile | 904.3 |
| Maximum | 932 |
| Range | 928 |
| Interquartile range (IQR) | 441 |
Descriptive statistics
| Standard deviation | 268.4522344 |
|---|---|
| Coefficient of variation (CV) | 0.5482527687 |
| Kurtosis | -1.152105309 |
| Mean | 489.6504854 |
| Median Absolute Deviation (MAD) | 224 |
| Skewness | -0.04097715684 |
| Sum | 50434 |
| Variance | 72066.60213 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 510 | 1 | 1.0% |
| 611 | 1 | 1.0% |
| 330 | 1 | 1.0% |
| 335 | 1 | 1.0% |
| 596 | 1 | 1.0% |
| 85 | 1 | 1.0% |
| 598 | 1 | 1.0% |
| 382 | 1 | 1.0% |
| 731 | 1 | 1.0% |
| 863 | 1 | 1.0% |
| Other values (93) | 93 |
| Value | Count | Frequency (%) |
| 4 | 1 | |
| 18 | 1 | |
| 24 | 1 | |
| 33 | 1 | |
| 40 | 1 | |
| 52 | 1 | |
| 73 | 1 | |
| 85 | 1 | |
| 107 | 1 | |
| 128 | 1 |
| Value | Count | Frequency (%) |
| 932 | 1 | |
| 926 | 1 | |
| 924 | 1 | |
| 923 | 1 | |
| 915 | 1 | |
| 906 | 1 | |
| 889 | 1 | |
| 877 | 1 | |
| 869 | 1 | |
| 863 | 1 |
Requester external ID
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIQUE| Distinct | 103 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8914559.019 |
| Minimum | 54194 |
|---|---|
| Maximum | 19066870 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 952.0 B |
Quantile statistics
| Minimum | 54194 |
|---|---|
| 5-th percentile | 506556.6 |
| Q1 | 4467439.5 |
| median | 8220013 |
| Q3 | 13809182.5 |
| 95-th percentile | 17307331.9 |
| Maximum | 19066870 |
| Range | 19012676 |
| Interquartile range (IQR) | 9341743 |
Descriptive statistics
| Standard deviation | 5635688.525 |
|---|---|
| Coefficient of variation (CV) | 0.6321892662 |
| Kurtosis | -1.209150668 |
| Mean | 8914559.019 |
| Median Absolute Deviation (MAD) | 4964030 |
| Skewness | 0.120628466 |
| Sum | 918199579 |
| Variance | 3.176098516 × 1013 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 853458 | 1 | 1.0% |
| 11072911 | 1 | 1.0% |
| 6806022 | 1 | 1.0% |
| 9823290 | 1 | 1.0% |
| 16626791 | 1 | 1.0% |
| 6552151 | 1 | 1.0% |
| 404518 | 1 | 1.0% |
| 13887500 | 1 | 1.0% |
| 8754504 | 1 | 1.0% |
| 5860014 | 1 | 1.0% |
| Other values (93) | 93 |
| Value | Count | Frequency (%) |
| 54194 | 1 | |
| 148875 | 1 | |
| 215927 | 1 | |
| 348718 | 1 | |
| 404518 | 1 | |
| 488335 | 1 | |
| 670551 | 1 | |
| 853458 | 1 | |
| 1009400 | 1 | |
| 1186403 | 1 |
| Value | Count | Frequency (%) |
| 19066870 | 1 | |
| 18814467 | 1 | |
| 18685771 | 1 | |
| 18685162 | 1 | |
| 18570294 | 1 | |
| 17326176 | 1 | |
| 17137735 | 1 | |
| 17050426 | 1 | |
| 16941342 | 1 | |
| 16920828 | 1 |
| Distinct | 70 |
|---|---|
| Distinct (%) | 68.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 952.0 B |
| Minimum | 2021-01-07 00:00:00 |
|---|---|
| Maximum | 2021-06-09 00:00:00 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 952.0 B |
| Reclame Aqui |
|---|
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Characters and Unicode
| Total characters | 1236 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Reclame Aqui |
|---|---|
| 2nd row | Reclame Aqui |
| 3rd row | Reclame Aqui |
| 4th row | Reclame Aqui |
| 5th row | Reclame Aqui |
Common Values
| Value | Count | Frequency (%) |
| Reclame Aqui | 103 |
Length
Pie chart
| Value | Count | Frequency (%) |
| reclame | 103 | |
| aqui | 103 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 206 | |
| R | 103 | |
| c | 103 | |
| l | 103 | |
| a | 103 | |
| m | 103 | |
| 103 | ||
| A | 103 | |
| q | 103 | |
| u | 103 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 927 | |
| Uppercase Letter | 206 | 16.7% |
| Space Separator | 103 | 8.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 206 | |
| c | 103 | |
| l | 103 | |
| a | 103 | |
| m | 103 | |
| q | 103 | |
| u | 103 | |
| i | 103 |
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 103 | |
| A | 103 |
Space Separator
| Value | Count | Frequency (%) |
| 103 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1133 | |
| Common | 103 | 8.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 206 | |
| R | 103 | |
| c | 103 | |
| l | 103 | |
| a | 103 | |
| m | 103 | |
| A | 103 | |
| q | 103 | |
| u | 103 | |
| i | 103 |
Common
| Value | Count | Frequency (%) |
| 103 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1236 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 206 | |
| R | 103 | |
| c | 103 | |
| l | 103 | |
| a | 103 | |
| m | 103 | |
| 103 | ||
| A | 103 | |
| q | 103 | |
| u | 103 |
| Distinct | 103 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3788058.282 |
| Minimum | 3489502 |
|---|---|
| Maximum | 4078417 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 952.0 B |
Quantile statistics
| Minimum | 3489502 |
|---|---|
| 5-th percentile | 3521645.3 |
| Q1 | 3615755 |
| median | 3795980 |
| Q3 | 3954945.5 |
| 95-th percentile | 4024304.4 |
| Maximum | 4078417 |
| Range | 588915 |
| Interquartile range (IQR) | 339190.5 |
Descriptive statistics
| Standard deviation | 179469.1107 |
|---|---|
| Coefficient of variation (CV) | 0.04737760017 |
| Kurtosis | -1.452945056 |
| Mean | 3788058.282 |
| Median Absolute Deviation (MAD) | 167224 |
| Skewness | -0.1176438073 |
| Sum | 390170003 |
| Variance | 3.220916169 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3596286 | 1 | 1.0% |
| 3752021 | 1 | 1.0% |
| 3953472 | 1 | 1.0% |
| 3963204 | 1 | 1.0% |
| 3794762 | 1 | 1.0% |
| 3758924 | 1 | 1.0% |
| 3977805 | 1 | 1.0% |
| 3976013 | 1 | 1.0% |
| 3516237 | 1 | 1.0% |
| 3965264 | 1 | 1.0% |
| Other values (93) | 93 |
| Value | Count | Frequency (%) |
| 3489502 | 1 | |
| 3497235 | 1 | |
| 3505433 | 1 | |
| 3516237 | 1 | |
| 3517190 | 1 | |
| 3521153 | 1 | |
| 3526076 | 1 | |
| 3527442 | 1 | |
| 3537166 | 1 | |
| 3537196 | 1 |
| Value | Count | Frequency (%) |
| 4078417 | 1 | |
| 4071584 | 1 | |
| 4069621 | 1 | |
| 4062341 | 1 | |
| 4030469 | 1 | |
| 4025110 | 1 | |
| 4017054 | 1 | |
| 4016762 | 1 | |
| 4012508 | 1 | |
| 4011570 | 1 |
| Distinct | 12 |
|---|---|
| Distinct (%) | 11.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 952.0 B |
| kaique.barbosa@gympass.com | |
|---|---|
| barbara.priscila@gympass.com | |
| suellen.franco+core@gympass.com | |
| danielle.hernandes@gympass.com | |
| luciana.melo@gympass.com | |
| Other values (7) |
Length
| Max length | 31 |
|---|---|
| Median length | 27 |
| Mean length | 27.52427184 |
| Min length | 23 |
Characters and Unicode
| Total characters | 2835 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | 2.9% |
Sample
| 1st row | gabriel.almeida@gympass.com |
|---|---|
| 2nd row | barbara.priscila@gympass.com |
| 3rd row | kaique.barbosa@gympass.com |
| 4th row | luciana.melo@gympass.com |
| 5th row | suellen.franco+core@gympass.com |
Common Values
| Value | Count | Frequency (%) |
| kaique.barbosa@gympass.com | 32 | |
| barbara.priscila@gympass.com | 16 | |
| suellen.franco+core@gympass.com | 15 | |
| danielle.hernandes@gympass.com | 14 | |
| luciana.melo@gympass.com | 10 | 9.7% |
| anderson.santos@gympass.com | 5 | 4.9% |
| gabriel.almeida@gympass.com | 3 | 2.9% |
| elizabete.damiao@gympass.com | 3 | 2.9% |
| caroline.roberto@gympass.com | 2 | 1.9% |
| yasmin.reis@gympass.com | 1 | 1.0% |
| Other values (2) | 2 | 1.9% |
Length
| Value | Count | Frequency (%) |
| kaique.barbosa@gympass.com | 32 | |
| barbara.priscila@gympass.com | 16 | |
| suellen.franco+core@gympass.com | 15 | |
| danielle.hernandes@gympass.com | 14 | |
| luciana.melo@gympass.com | 10 | 9.7% |
| anderson.santos@gympass.com | 5 | 4.9% |
| gabriel.almeida@gympass.com | 3 | 2.9% |
| elizabete.damiao@gympass.com | 3 | 2.9% |
| caroline.roberto@gympass.com | 2 | 1.9% |
| yasmin.reis@gympass.com | 1 | 1.0% |
| Other values (2) | 2 | 1.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 359 | |
| s | 301 | 10.6% |
| m | 224 | 7.9% |
| . | 206 | 7.3% |
| o | 199 | 7.0% |
| e | 171 | 6.0% |
| c | 163 | 5.7% |
| r | 141 | 5.0% |
| p | 119 | 4.2% |
| l | 108 | 3.8% |
| Other values (15) | 844 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2511 | |
| Other Punctuation | 309 | 10.9% |
| Math Symbol | 15 | 0.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 359 | |
| s | 301 | |
| m | 224 | 8.9% |
| o | 199 | 7.9% |
| e | 171 | 6.8% |
| c | 163 | 6.5% |
| r | 141 | 5.6% |
| p | 119 | 4.7% |
| l | 108 | 4.3% |
| g | 106 | 4.2% |
| Other values (12) | 620 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 206 | |
| @ | 103 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 15 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2511 | |
| Common | 324 | 11.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 359 | |
| s | 301 | |
| m | 224 | 8.9% |
| o | 199 | 7.9% |
| e | 171 | 6.8% |
| c | 163 | 6.5% |
| r | 141 | 5.6% |
| p | 119 | 4.7% |
| l | 108 | 4.3% |
| g | 106 | 4.2% |
| Other values (12) | 620 |
Common
| Value | Count | Frequency (%) |
| . | 206 | |
| @ | 103 | |
| + | 15 | 4.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2835 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 359 | |
| s | 301 | 10.6% |
| m | 224 | 7.9% |
| . | 206 | 7.3% |
| o | 199 | 7.0% |
| e | 171 | 6.0% |
| c | 163 | 5.7% |
| r | 141 | 5.0% |
| p | 119 | 4.2% |
| l | 108 | 3.8% |
| Other values (15) | 844 |
| Distinct | 103 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 952.0 B |
| camilampm@yahoo.com.br | 1 |
|---|---|
| alexandropersi@gmail.com | 1 |
| thais.arruda.silva@gmail.com | 1 |
| giovana.sanini@buser.com.br | 1 |
| wander@fasa.edu.br | 1 |
| Other values (98) |
Length
| Max length | 62 |
|---|---|
| Median length | 25 |
| Mean length | 25.21359223 |
| Min length | 16 |
Characters and Unicode
| Total characters | 2597 |
|---|---|
| Distinct characters | 40 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 103 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | nancy.jikihara@voith.com |
|---|---|
| 2nd row | wesbley.carvalho@livup.com.br |
| 3rd row | laura.andrade@erm.com |
| 4th row | guilhermequintino@gmail.com |
| 5th row | joice.bertechini@gmail.com |
Common Values
| Value | Count | Frequency (%) |
| camilampm@yahoo.com.br | 1 | 1.0% |
| alexandropersi@gmail.com | 1 | 1.0% |
| thais.arruda.silva@gmail.com | 1 | 1.0% |
| giovana.sanini@buser.com.br | 1 | 1.0% |
| wander@fasa.edu.br | 1 | 1.0% |
| na.matiolli@gmail.com | 1 | 1.0% |
| guilhermemoura403@gmail.com | 1 | 1.0% |
| ricardodegoescorreia@gmail.com | 1 | 1.0% |
| smtreinamentofuncional@gmail.com | 1 | 1.0% |
| sergiotgbarros@uol.com.br | 1 | 1.0% |
| Other values (93) | 93 |
Length
| Value | Count | Frequency (%) |
| camilampm@yahoo.com.br | 1 | 1.0% |
| alexandropersi@gmail.com | 1 | 1.0% |
| thais.arruda.silva@gmail.com | 1 | 1.0% |
| giovana.sanini@buser.com.br | 1 | 1.0% |
| wander@fasa.edu.br | 1 | 1.0% |
| na.matiolli@gmail.com | 1 | 1.0% |
| guilhermemoura403@gmail.com | 1 | 1.0% |
| ricardodegoescorreia@gmail.com | 1 | 1.0% |
| smtreinamentofuncional@gmail.com | 1 | 1.0% |
| sergiotgbarros@uol.com.br | 1 | 1.0% |
| Other values (93) | 93 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 287 | 11.1% |
| o | 262 | 10.1% |
| m | 216 | 8.3% |
| i | 179 | 6.9% |
| l | 166 | 6.4% |
| . | 163 | 6.3% |
| c | 152 | 5.9% |
| r | 138 | 5.3% |
| e | 127 | 4.9% |
| @ | 103 | 4.0% |
| Other values (30) | 804 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2223 | |
| Other Punctuation | 266 | 10.2% |
| Decimal Number | 85 | 3.3% |
| Dash Punctuation | 14 | 0.5% |
| Connector Punctuation | 9 | 0.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 287 | |
| o | 262 | |
| m | 216 | |
| i | 179 | 8.1% |
| l | 166 | 7.5% |
| c | 152 | 6.8% |
| r | 138 | 6.2% |
| e | 127 | 5.7% |
| s | 95 | 4.3% |
| n | 89 | 4.0% |
| Other values (16) | 512 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 14 | |
| 0 | 13 | |
| 6 | 10 | |
| 2 | 10 | |
| 8 | 9 | |
| 5 | 7 | |
| 9 | 7 | |
| 3 | 6 | |
| 4 | 5 | 5.9% |
| 7 | 4 | 4.7% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 163 | |
| @ | 103 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 14 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 9 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2223 | |
| Common | 374 | 14.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 287 | |
| o | 262 | |
| m | 216 | |
| i | 179 | 8.1% |
| l | 166 | 7.5% |
| c | 152 | 6.8% |
| r | 138 | 6.2% |
| e | 127 | 5.7% |
| s | 95 | 4.3% |
| n | 89 | 4.0% |
| Other values (16) | 512 |
Common
| Value | Count | Frequency (%) |
| . | 163 | |
| @ | 103 | |
| - | 14 | 3.7% |
| 1 | 14 | 3.7% |
| 0 | 13 | 3.5% |
| 6 | 10 | 2.7% |
| 2 | 10 | 2.7% |
| _ | 9 | 2.4% |
| 8 | 9 | 2.4% |
| 5 | 7 | 1.9% |
| Other values (4) | 22 | 5.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2597 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 287 | 11.1% |
| o | 262 | 10.1% |
| m | 216 | 8.3% |
| i | 179 | 6.9% |
| l | 166 | 6.4% |
| . | 163 | 6.3% |
| c | 152 | 5.9% |
| r | 138 | 5.3% |
| e | 127 | 4.9% |
| @ | 103 | 4.0% |
| Other values (30) | 804 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 952.0 B |
| 1 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 103 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 103 |
Length
Pie chart
| Value | Count | Frequency (%) |
| 1 | 103 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 103 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 103 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 103 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 103 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 103 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 103 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 103 |
Requester_ID
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIQUE| Distinct | 103 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8914559.019 |
| Minimum | 54194 |
|---|---|
| Maximum | 19066870 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 952.0 B |
Quantile statistics
| Minimum | 54194 |
|---|---|
| 5-th percentile | 506556.6 |
| Q1 | 4467439.5 |
| median | 8220013 |
| Q3 | 13809182.5 |
| 95-th percentile | 17307331.9 |
| Maximum | 19066870 |
| Range | 19012676 |
| Interquartile range (IQR) | 9341743 |
Descriptive statistics
| Standard deviation | 5635688.525 |
|---|---|
| Coefficient of variation (CV) | 0.6321892662 |
| Kurtosis | -1.209150668 |
| Mean | 8914559.019 |
| Median Absolute Deviation (MAD) | 4964030 |
| Skewness | 0.120628466 |
| Sum | 918199579 |
| Variance | 3.176098516 × 1013 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 16920828 | 1 | 1.0% |
| 17326176 | 1 | 1.0% |
| 17137735 | 1 | 1.0% |
| 8754504 | 1 | 1.0% |
| 13359056 | 1 | 1.0% |
| 5399885 | 1 | 1.0% |
| 5989712 | 1 | 1.0% |
| 3350869 | 1 | 1.0% |
| 6552151 | 1 | 1.0% |
| 8777560 | 1 | 1.0% |
| Other values (93) | 93 |
| Value | Count | Frequency (%) |
| 54194 | 1 | |
| 148875 | 1 | |
| 215927 | 1 | |
| 348718 | 1 | |
| 404518 | 1 | |
| 488335 | 1 | |
| 670551 | 1 | |
| 853458 | 1 | |
| 1009400 | 1 | |
| 1186403 | 1 |
| Value | Count | Frequency (%) |
| 19066870 | 1 | |
| 18814467 | 1 | |
| 18685771 | 1 | |
| 18685162 | 1 | |
| 18570294 | 1 | |
| 17326176 | 1 | |
| 17137735 | 1 | |
| 17050426 | 1 | |
| 16941342 | 1 | |
| 16920828 | 1 |
| Distinct | 11 |
|---|---|
| Distinct (%) | 10.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.650485437 |
| Minimum | 0 |
|---|---|
| Maximum | 16 |
| Zeros | 1 |
| Zeros (%) | 1.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 952.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 7.9 |
| Maximum | 16 |
| Range | 16 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2.371020868 |
|---|---|
| Coefficient of variation (CV) | 0.894560987 |
| Kurtosis | 9.856650226 |
| Mean | 2.650485437 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.592026464 |
| Sum | 273 |
| Variance | 5.621739958 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 44 | |
| 3 | 19 | |
| 2 | 15 | 14.6% |
| 4 | 10 | 9.7% |
| 5 | 6 | 5.8% |
| 9 | 3 | 2.9% |
| 8 | 2 | 1.9% |
| 0 | 1 | 1.0% |
| 7 | 1 | 1.0% |
| 16 | 1 | 1.0% |
| Value | Count | Frequency (%) |
| 0 | 1 | 1.0% |
| 1 | 44 | |
| 2 | 15 | 14.6% |
| 3 | 19 | |
| 4 | 10 | 9.7% |
| 5 | 6 | 5.8% |
| 6 | 1 | 1.0% |
| 7 | 1 | 1.0% |
| 8 | 2 | 1.9% |
| 9 | 3 | 2.9% |
| Value | Count | Frequency (%) |
| 16 | 1 | 1.0% |
| 9 | 3 | 2.9% |
| 8 | 2 | 1.9% |
| 7 | 1 | 1.0% |
| 6 | 1 | 1.0% |
| 5 | 6 | 5.8% |
| 4 | 10 | 9.7% |
| 3 | 19 | |
| 2 | 15 | 14.6% |
| 1 | 44 |
| Distinct | 6 |
|---|---|
| Distinct (%) | 5.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.563106796 |
| Minimum | 1 |
|---|---|
| Maximum | 8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 952.0 B |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 8 |
| Range | 7 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.025841624 |
|---|---|
| Coefficient of variation (CV) | 0.6562837719 |
| Kurtosis | 15.39185153 |
| Mean | 1.563106796 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.244045751 |
| Sum | 161 |
| Variance | 1.052351038 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 66 | |
| 2 | 25 | 24.3% |
| 3 | 8 | 7.8% |
| 4 | 2 | 1.9% |
| 5 | 1 | 1.0% |
| 8 | 1 | 1.0% |
| Value | Count | Frequency (%) |
| 1 | 66 | |
| 2 | 25 | 24.3% |
| 3 | 8 | 7.8% |
| 4 | 2 | 1.9% |
| 5 | 1 | 1.0% |
| 8 | 1 | 1.0% |
| Value | Count | Frequency (%) |
| 8 | 1 | 1.0% |
| 5 | 1 | 1.0% |
| 4 | 2 | 1.9% |
| 3 | 8 | 7.8% |
| 2 | 25 | 24.3% |
| 1 | 66 |
| Distinct | 101 |
|---|---|
| Distinct (%) | 99.0% |
| Missing | 1 |
| Missing (%) | 1.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1376.588235 |
| Minimum | 15 |
|---|---|
| Maximum | 3114 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 952.0 B |
Quantile statistics
| Minimum | 15 |
|---|---|
| 5-th percentile | 418.9 |
| Q1 | 918.25 |
| median | 1323 |
| Q3 | 1716.25 |
| 95-th percentile | 2680.75 |
| Maximum | 3114 |
| Range | 3099 |
| Interquartile range (IQR) | 798 |
Descriptive statistics
| Standard deviation | 650.0578398 |
|---|---|
| Coefficient of variation (CV) | 0.4722238816 |
| Kurtosis | 0.05939509507 |
| Mean | 1376.588235 |
| Median Absolute Deviation (MAD) | 397 |
| Skewness | 0.5083057296 |
| Sum | 140412 |
| Variance | 422575.1951 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1952 | 2 | 1.9% |
| 2143 | 1 | 1.0% |
| 726 | 1 | 1.0% |
| 1360 | 1 | 1.0% |
| 436 | 1 | 1.0% |
| 1512 | 1 | 1.0% |
| 57 | 1 | 1.0% |
| 878 | 1 | 1.0% |
| 816 | 1 | 1.0% |
| 2681 | 1 | 1.0% |
| Other values (91) | 91 |
| Value | Count | Frequency (%) |
| 15 | 1 | |
| 57 | 1 | |
| 377 | 1 | |
| 384 | 1 | |
| 413 | 1 | |
| 418 | 1 | |
| 436 | 1 | |
| 552 | 1 | |
| 553 | 1 | |
| 555 | 1 |
| Value | Count | Frequency (%) |
| 3114 | 1 | |
| 2899 | 1 | |
| 2769 | 1 | |
| 2722 | 1 | |
| 2689 | 1 | |
| 2681 | 1 | |
| 2676 | 1 | |
| 2607 | 1 | |
| 2546 | 1 | |
| 2440 | 1 |
| Distinct | 102 |
|---|---|
| Distinct (%) | 99.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11334.81553 |
| Minimum | 1470 |
|---|---|
| Maximum | 57865 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 952.0 B |
Quantile statistics
| Minimum | 1470 |
|---|---|
| 5-th percentile | 2669.1 |
| Q1 | 5254 |
| median | 8286 |
| Q3 | 14934 |
| 95-th percentile | 27134.9 |
| Maximum | 57865 |
| Range | 56395 |
| Interquartile range (IQR) | 9680 |
Descriptive statistics
| Standard deviation | 9048.550857 |
|---|---|
| Coefficient of variation (CV) | 0.7982971429 |
| Kurtosis | 6.65449322 |
| Mean | 11334.81553 |
| Median Absolute Deviation (MAD) | 4375 |
| Skewness | 2.097650557 |
| Sum | 1167486 |
| Variance | 81876272.6 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15843 | 2 | 1.9% |
| 17543 | 1 | 1.0% |
| 22396 | 1 | 1.0% |
| 6820 | 1 | 1.0% |
| 11780 | 1 | 1.0% |
| 3238 | 1 | 1.0% |
| 8286 | 1 | 1.0% |
| 3442 | 1 | 1.0% |
| 18904 | 1 | 1.0% |
| 10625 | 1 | 1.0% |
| Other values (92) | 92 |
| Value | Count | Frequency (%) |
| 1470 | 1 | |
| 1932 | 1 | |
| 2183 | 1 | |
| 2244 | 1 | |
| 2569 | 1 | |
| 2640 | 1 | |
| 2931 | 1 | |
| 3061 | 1 | |
| 3121 | 1 | |
| 3207 | 1 |
| Value | Count | Frequency (%) |
| 57865 | 1 | |
| 38520 | 1 | |
| 34728 | 1 | |
| 32539 | 1 | |
| 32015 | 1 | |
| 27191 | 1 | |
| 26630 | 1 | |
| 23832 | 1 | |
| 22733 | 1 | |
| 22712 | 1 |
| Distinct | 66 |
|---|---|
| Distinct (%) | 64.7% |
| Missing | 1 |
| Missing (%) | 1.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 152.0098039 |
| Minimum | 7 |
|---|---|
| Maximum | 1981 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 952.0 B |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 18.5 |
| median | 37.5 |
| Q3 | 113.5 |
| 95-th percentile | 680.95 |
| Maximum | 1981 |
| Range | 1974 |
| Interquartile range (IQR) | 95 |
Descriptive statistics
| Standard deviation | 301.0175974 |
|---|---|
| Coefficient of variation (CV) | 1.980251205 |
| Kurtosis | 19.32820308 |
| Mean | 152.0098039 |
| Median Absolute Deviation (MAD) | 26.5 |
| Skewness | 4.015252905 |
| Sum | 15505 |
| Variance | 90611.59396 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7 | 5 | 4.9% |
| 33 | 5 | 4.9% |
| 11 | 4 | 3.9% |
| 24 | 4 | 3.9% |
| 8 | 3 | 2.9% |
| 13 | 3 | 2.9% |
| 35 | 3 | 2.9% |
| 23 | 3 | 2.9% |
| 14 | 3 | 2.9% |
| 115 | 2 | 1.9% |
| Other values (56) | 67 |
| Value | Count | Frequency (%) |
| 7 | 5 | |
| 8 | 3 | |
| 9 | 1 | 1.0% |
| 11 | 4 | |
| 12 | 2 | 1.9% |
| 13 | 3 | |
| 14 | 3 | |
| 16 | 2 | 1.9% |
| 17 | 2 | 1.9% |
| 18 | 1 | 1.0% |
| Value | Count | Frequency (%) |
| 1981 | 1 | |
| 1691 | 1 | |
| 843 | 1 | |
| 801 | 1 | |
| 765 | 1 | |
| 689 | 1 | |
| 528 | 1 | |
| 517 | 1 | |
| 479 | 1 | |
| 429 | 1 |
| Distinct | 19 |
|---|---|
| Distinct (%) | 18.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.3170832705 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 28 |
| Zeros (%) | 27.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 952.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.3333333333 |
| Q3 | 0.5 |
| 95-th percentile | 0.6666666667 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.5 |
Descriptive statistics
| Standard deviation | 0.2370517885 |
|---|---|
| Coefficient of variation (CV) | 0.747601058 |
| Kurtosis | -0.7273449227 |
| Mean | 0.3170832705 |
| Median Absolute Deviation (MAD) | 0.1666666667 |
| Skewness | 0.0564166741 |
| Sum | 32.65957686 |
| Variance | 0.05619355043 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 28 | |
| 0.5 | 25 | |
| 0.3333333333 | 13 | |
| 0.25 | 8 | 7.8% |
| 0.4 | 5 | 4.9% |
| 0.2 | 4 | 3.9% |
| 0.6666666667 | 4 | 3.9% |
| 0.1666666667 | 2 | 1.9% |
| 0.6 | 2 | 1.9% |
| 0.3 | 2 | 1.9% |
| Other values (9) | 10 | 9.7% |
| Value | Count | Frequency (%) |
| 0 | 28 | |
| 0.1666666667 | 2 | 1.9% |
| 0.2 | 4 | 3.9% |
| 0.25 | 8 | 7.8% |
| 0.3 | 2 | 1.9% |
| 0.3333333333 | 13 | |
| 0.375 | 1 | 1.0% |
| 0.4 | 5 | 4.9% |
| 0.4285714286 | 1 | 1.0% |
| 0.4444444444 | 1 | 1.0% |
| Value | Count | Frequency (%) |
| 1 | 1 | 1.0% |
| 0.75 | 2 | 1.9% |
| 0.7142857143 | 1 | 1.0% |
| 0.6666666667 | 4 | 3.9% |
| 0.6470588235 | 1 | 1.0% |
| 0.6 | 2 | 1.9% |
| 0.5714285714 | 1 | 1.0% |
| 0.5454545455 | 1 | 1.0% |
| 0.5 | 25 | |
| 0.4444444444 | 1 | 1.0% |
| Distinct | 8 |
|---|---|
| Distinct (%) | 7.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2897311426 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 66 |
| Zeros (%) | 64.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 952.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.5 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.5 |
Descriptive statistics
| Standard deviation | 0.4184600572 |
|---|---|
| Coefficient of variation (CV) | 1.444304721 |
| Kurtosis | -0.9258565024 |
| Mean | 0.2897311426 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.9332667072 |
| Sum | 29.84230769 |
| Variance | 0.1751088195 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 66 | |
| 1 | 23 | 22.3% |
| 0.5 | 9 | 8.7% |
| 0.3333333333 | 1 | 1.0% |
| 0.4 | 1 | 1.0% |
| 0.6923076923 | 1 | 1.0% |
| 0.6666666667 | 1 | 1.0% |
| 0.25 | 1 | 1.0% |
| Value | Count | Frequency (%) |
| 0 | 66 | |
| 0.25 | 1 | 1.0% |
| 0.3333333333 | 1 | 1.0% |
| 0.4 | 1 | 1.0% |
| 0.5 | 9 | 8.7% |
| 0.6666666667 | 1 | 1.0% |
| 0.6923076923 | 1 | 1.0% |
| 1 | 23 | 22.3% |
| Value | Count | Frequency (%) |
| 1 | 23 | 22.3% |
| 0.6923076923 | 1 | 1.0% |
| 0.6666666667 | 1 | 1.0% |
| 0.5 | 9 | 8.7% |
| 0.4 | 1 | 1.0% |
| 0.3333333333 | 1 | 1.0% |
| 0.25 | 1 | 1.0% |
| 0 | 66 |
CSAT_Rated
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 8 |
|---|---|
| Distinct (%) | 7.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.203883495 |
| Minimum | 0 |
|---|---|
| Maximum | 13 |
| Zeros | 34 |
| Zeros (%) | 33.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 952.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 13 |
| Range | 13 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.62914162 |
|---|---|
| Coefficient of variation (CV) | 1.353238604 |
| Kurtosis | 27.12441364 |
| Mean | 1.203883495 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 4.269709731 |
| Sum | 124 |
| Variance | 2.654102418 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 39 | |
| 0 | 34 | |
| 2 | 23 | |
| 5 | 2 | 1.9% |
| 3 | 2 | 1.9% |
| 13 | 1 | 1.0% |
| 6 | 1 | 1.0% |
| 4 | 1 | 1.0% |
| Value | Count | Frequency (%) |
| 0 | 34 | |
| 1 | 39 | |
| 2 | 23 | |
| 3 | 2 | 1.9% |
| 4 | 1 | 1.0% |
| 5 | 2 | 1.9% |
| 6 | 1 | 1.0% |
| 13 | 1 | 1.0% |
| Value | Count | Frequency (%) |
| 13 | 1 | 1.0% |
| 6 | 1 | 1.0% |
| 5 | 2 | 1.9% |
| 4 | 1 | 1.0% |
| 3 | 2 | 1.9% |
| 2 | 23 | |
| 1 | 39 | |
| 0 | 34 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| df_index | Requester external ID | Ticket created - Date | Channel | Ticket ID | Assignee email | Requester email | Tickets | Requester_ID | Volume_CHAT | Volume_EMAIL | Volume_SOCIAL | Tempo_Medio_Chat | Tempo_Medio_Email | Tempo_Medio_Social | AWT_Chat | %NFCR | %Insatisfação(CSAT) | CSAT_Rated | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 4 | 54194.0 | 2021-03-22 | Reclame Aqui | 3795980 | gabriel.almeida@gympass.com | nancy.jikihara@voith.com | 1 | 54194 | 1.0 | 1.0 | NaN | 1066.0 | 57865.0 | NaN | 169.0 | 0.500000 | 1.0 | 1 |
| 1 | 18 | 148875.0 | 2021-05-07 | Reclame Aqui | 3956419 | barbara.priscila@gympass.com | wesbley.carvalho@livup.com.br | 1 | 148875 | 6.0 | 1.0 | NaN | 1309.0 | 23832.0 | NaN | 138.0 | 0.714286 | 1.0 | 1 |
| 2 | 24 | 215927.0 | 2021-01-26 | Reclame Aqui | 3568930 | kaique.barbosa@gympass.com | laura.andrade@erm.com | 1 | 215927 | 3.0 | 1.0 | NaN | 1884.0 | 1932.0 | NaN | 14.0 | 0.250000 | 1.0 | 1 |
| 3 | 33 | 348718.0 | 2021-05-04 | Reclame Aqui | 3943532 | luciana.melo@gympass.com | guilhermequintino@gmail.com | 1 | 348718 | 1.0 | 1.0 | NaN | 1688.0 | 32539.0 | NaN | 89.0 | 0.000000 | 1.0 | 1 |
| 4 | 40 | 404518.0 | 2021-02-09 | Reclame Aqui | 3629138 | suellen.franco+core@gympass.com | joice.bertechini@gmail.com | 1 | 404518 | 3.0 | 1.0 | NaN | 1728.0 | 10625.0 | NaN | 87.0 | 0.250000 | 0.0 | 2 |
| 5 | 52 | 488335.0 | 2021-01-27 | Reclame Aqui | 3574448 | danielle.hernandes@gympass.com | vanessa-fcampos@hotmail.com | 1 | 488335 | 2.0 | 1.0 | NaN | 1224.0 | 11389.0 | NaN | 33.0 | 0.666667 | 1.0 | 2 |
| 6 | 73 | 670551.0 | 2021-02-01 | Reclame Aqui | 3589849 | kaique.barbosa@gympass.com | luba_balbal@hotmail.com | 1 | 670551 | 3.0 | 1.0 | NaN | 1952.0 | 5178.0 | NaN | 11.0 | 0.000000 | 0.0 | 0 |
| 7 | 85 | 853458.0 | 2021-05-26 | Reclame Aqui | 4025110 | kaique.barbosa@gympass.com | sergiotgbarros@uol.com.br | 1 | 853458 | 1.0 | 8.0 | NaN | 1477.0 | 10458.0 | NaN | 7.0 | 0.750000 | 0.0 | 0 |
| 8 | 107 | 1009400.0 | 2021-05-11 | Reclame Aqui | 3969476 | barbara.priscila@gympass.com | bmenndes@gmail.com | 1 | 1009400 | 2.0 | 3.0 | NaN | 1324.0 | 6792.0 | NaN | 35.0 | 0.333333 | 0.0 | 0 |
| 9 | 128 | 1186403.0 | 2021-05-05 | Reclame Aqui | 3947655 | barbara.priscila@gympass.com | luanycardoso@gmail.com | 1 | 1186403 | 3.0 | 1.0 | NaN | 1322.0 | 3121.0 | NaN | 11.0 | 0.250000 | 0.0 | 2 |
Last rows
| df_index | Requester external ID | Ticket created - Date | Channel | Ticket ID | Assignee email | Requester email | Tickets | Requester_ID | Volume_CHAT | Volume_EMAIL | Volume_SOCIAL | Tempo_Medio_Chat | Tempo_Medio_Email | Tempo_Medio_Social | AWT_Chat | %NFCR | %Insatisfação(CSAT) | CSAT_Rated | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 93 | 863 | 16920828.0 | 2021-01-22 | Reclame Aqui | 3557795 | kaique.barbosa@gympass.com | caroline.bonesi@gmail.com | 1 | 16920828 | 1.0 | 2.0 | NaN | 961.0 | 7892.0 | NaN | 13.0 | 0.333333 | 1.00 | 1 |
| 94 | 869 | 16941342.0 | 2021-04-30 | Reclame Aqui | 3929623 | kaique.barbosa@gympass.com | ex.ravem666@gmail.com | 1 | 16941342 | 3.0 | 3.0 | NaN | 821.0 | 11219.0 | NaN | 72.0 | 0.500000 | 1.00 | 2 |
| 95 | 877 | 17050426.0 | 2021-05-10 | Reclame Aqui | 3963204 | kaique.barbosa@gympass.com | bina131@live.com | 1 | 17050426 | 1.0 | 1.0 | NaN | 665.0 | 12316.0 | NaN | 109.0 | 0.000000 | 1.00 | 1 |
| 96 | 889 | 17137735.0 | 2021-05-24 | Reclame Aqui | 4011570 | danielle.hernandes@gympass.com | mauricio.miranda@stone.com.br | 1 | 17137735 | 4.0 | 1.0 | NaN | 1754.0 | 7338.0 | NaN | 23.0 | 0.400000 | 1.00 | 2 |
| 97 | 906 | 17326176.0 | 2021-04-12 | Reclame Aqui | 3865534 | danielle.hernandes@gympass.com | cristiano.body@gmail.com | 1 | 17326176 | 1.0 | 1.0 | NaN | 418.0 | 3553.0 | NaN | 46.0 | 0.000000 | 0.00 | 1 |
| 98 | 915 | 18570294.0 | 2021-04-20 | Reclame Aqui | 3892841 | danielle.hernandes@gympass.com | fabionunesp@hotmail.com | 1 | 18570294 | 2.0 | 4.0 | NaN | 2769.0 | 38520.0 | NaN | 11.0 | 0.500000 | 0.00 | 1 |
| 99 | 923 | 18685162.0 | 2021-05-19 | Reclame Aqui | 3996381 | barbara.priscila@gympass.com | thales.berdu@bayer.com | 1 | 18685162 | 1.0 | 2.0 | NaN | 1013.0 | 12767.0 | NaN | 1691.0 | 0.500000 | 1.00 | 1 |
| 100 | 924 | 18685771.0 | 2021-05-18 | Reclame Aqui | 3993205 | kaique.barbosa@gympass.com | andre.martins@modal.com.br | 1 | 18685771 | 5.0 | 1.0 | NaN | 962.0 | 11879.0 | NaN | 332.0 | 0.500000 | 0.25 | 4 |
| 101 | 926 | 18814467.0 | 2021-05-24 | Reclame Aqui | 4012508 | barbara.priscila@gympass.com | flaviaduarte@vooal.com | 1 | 18814467 | 1.0 | 3.0 | NaN | 1333.0 | 6891.0 | NaN | 14.0 | 0.250000 | 0.00 | 0 |
| 102 | 932 | 19066870.0 | 2021-01-07 | Reclame Aqui | 3489502 | suellen.franco+core@gympass.com | lucashaddadf@gmail.com | 1 | 19066870 | 1.0 | 1.0 | NaN | 1717.0 | 2931.0 | NaN | 38.0 | 0.000000 | 0.00 | 0 |